﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ht.aspx.cs" Inherits="nbfactory.ht" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
                <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                <asp:BoundField DataField="picu" HeaderText="picu" SortExpression="picu" />
                <asp:BoundField DataField="sm" HeaderText="sm" SortExpression="sm" />
                <asp:BoundField DataField="ctz" HeaderText="ctz" SortExpression="ctz" />
                <asp:CommandField />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [facprdt] WHERE [Id] = @original_Id AND (([picu] = @original_picu) OR ([picu] IS NULL AND @original_picu IS NULL)) AND (([sm] = @original_sm) OR ([sm] IS NULL AND @original_sm IS NULL)) AND (([ctz] = @original_ctz) OR ([ctz] IS NULL AND @original_ctz IS NULL))" InsertCommand="INSERT INTO [facprdt] ([Id], [picu], [sm], [ctz]) VALUES (@Id, @picu, @sm, @ctz)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [facprdt]" UpdateCommand="UPDATE [facprdt] SET [picu] = @picu, [sm] = @sm, [ctz] = @ctz WHERE [Id] = @original_Id AND (([picu] = @original_picu) OR ([picu] IS NULL AND @original_picu IS NULL)) AND (([sm] = @original_sm) OR ([sm] IS NULL AND @original_sm IS NULL)) AND (([ctz] = @original_ctz) OR ([ctz] IS NULL AND @original_ctz IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_Id" Type="Int32" />
                <asp:Parameter Name="original_picu" Type="String" />
                <asp:Parameter Name="original_sm" Type="String" />
                <asp:Parameter Name="original_ctz" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="Id" Type="Int32" />
                <asp:Parameter Name="picu" Type="String" />
                <asp:Parameter Name="sm" Type="String" />
                <asp:Parameter Name="ctz" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="picu" Type="String" />
                <asp:Parameter Name="sm" Type="String" />
                <asp:Parameter Name="ctz" Type="String" />
                <asp:Parameter Name="original_Id" Type="Int32" />
                <asp:Parameter Name="original_picu" Type="String" />
                <asp:Parameter Name="original_sm" Type="String" />
                <asp:Parameter Name="original_ctz" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>
